create view V_ServiceType
as

select cs.*,st.STName,ch.ChanName,u1.UserName CSCreateName,u2.UserName CSDueName
from CustomServices cs left join ServiceType st on cs.STID=st.STID 
left join Customers ct on cs.CusID=ct.CusID left join Chances ch on cs.CSName=ch.ChanName
left join Users u1 on cs.CSCreateID=u1.UserID left join Users u2 on cs.CSDueID =u2.UserID

go
select * from V_ServiceType